﻿CREATE TABLE [dbo].[Visits]
(
[OID] [bigint] NOT NULL IDENTITY(1, 1),
[Version] [timestamp] NOT NULL,
[CaseID] [bigint] NOT NULL,
[ArrivalDate] [datetime] NULL,
[DischargeDate] [datetime] NULL,
[FacilityID] [bigint] NOT NULL,
[EstimatedLOS] [int] NULL,
[FamilyPresent] [bit] NOT NULL,
[FamilyArrivalDate] [datetime] NULL,
[FamilyDepartureDate] [datetime] NULL,
[FamilyEstimatedLOS] [int] NULL,
[MethodOfTravel] [varchar] (128) NULL,
[OriginOfTravel] [varchar] (128) NULL,
[InvitationalTravelOrders] [bit] NULL,
[UpdatedDate] [datetime] NOT NULL,
[CreatedDate] [datetime] NOT NULL
) ON [PRIMARY]


